
create view vw_IT as
select * from Item

select *
from vw_IT

insert into vw_IT values('RKSK-W','Rucksack-Brown',400)
update vw_IT
set rate = 500
where ICode = 'RKSK-W'

select * from vw_IT

select * from Item

create proc HTCus
as
print 'Good'
select * from Customer where CCode = 'TLT'


create proc HTCus1 
@v_Ccode nvarchar(50)
as
select * from Customer where CCode = @v_Ccode

exec HTCus1 'TLT'

-- Bat loi 
Begin Try
	exec HTCus1
End Try